﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ERP_RORZE_PERMISSION.Base.Objects
{
    public class ClsCheckIn
    {
        
        public static DataTable CheckUser(string user, string Pass)
        {
            string sql = "select * from [222_Users] where [UserName] = " + user + " AND [Password] = "+Pass+"";
            return BaseDAO.ExecuteQuery(sql);

        }

        public static DataTable GetPermission(string user)
        {
            string sql = "select * from [222_User], [222_Permission] where [222_User].UserGroupID = [222_Permission].UserGroupID AND [222_User].UserName = " + user + "";
            return BaseDAO.ExecuteQuery(sql);
        }
    }
}
